Create Databases
8
Steps to Create a Database in SQL Server Management Studio
Step 1: Open SQL Server
To start, open Microsoft
SQL Server Management Studio.
To avoid any permission
issues, you may want to run SQL Server Management Studio as an administrator:

Step 2: Connect to your Server

Step 3 : Create your Database
Under the Object Explorer,
you’ll see the Databases Folder. Right click on that folder
and then select New
Database… from the drop-down list
Reminder: If you don’t see the newly created database then Right-click on
the Databases folder
under the Object Explorer, and then select Refresh from the
drop-down list:
We
will create 3 databases for this project:
· GunViolenceStaging
· GunViolence_ODS
· GunViolence_DW


Here are the links to download SQL Server Management Studio(SSMS) and SQL Server Data Tools:
SSMS
https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15#previous-ssms-releases
SSDT https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15